Deposit types
Deposit types contribute the GL batch and bank account to all receipts in deposits of their type.
Typical deposit types include cash/checks, MC/Visa, AMEX, lock box, and PayPal.
- In the Navigation pane, highlight the Accounts Receivable > Setup > Deposit Types folder.
- Click . The New Deposit Type window opens.
-
Enter a unique Code for the deposit type.
Examples
- Cash/Checks
- MC/Visa
- AMEX
- Lock Box
- PayPal
- Enter a Description of the deposit type.
- In the GL Batch field, enter the GL batch name to associate with the deposit type. The batch name is used on all deposit receipts for the deposit type. This ensures that all receipts for a given deposit type are summarized into the same GL entry.
- In the Bank Account field, select the bank account to which to post deposit receipts for this deposit type. All receipts for a given deposit type must post to the same bank account to ensure the appropriate bank reconciliation transaction is generated.
-
In the Deposit Reference field, enter the literal text and/or keywords to use to generate the deposit reference that appears on deposits of this type. The deposit reference can be up to 20 characters long. The reference is copied to the bank reconciliation transaction's Reference field when the transaction is created during GL merge.
Changes to the deposit type do not affect existing deposits, so you can change how the deposit reference is generated on future deposits without impacting existing deposits.
-
In the Deposit Description field, enter the literal text and/or keywords to use to generate the deposit description you want to appear on deposits of this type. The deposit description can be up to 40 characters long. The description is copied to the bank reconciliation transaction's Description field when the transaction is created during GL merge.
Example - multiple receipts on a deposit
- Deposit Reference: <Receipt Count> Receipt(s)
- Deposit Description: <Deposit Name>
Example - one receipt per deposit
Suppose you have a deposit type called "AMEX" for American Express credit card receipts. Because you want to generate one receipt per credit card transaction, the deposit type is flagged as "One Receipt per Deposit". You want the deposit reference to consist of the credit card machine number and the "batch out number". The "batch out number" comes from the receipt reference; the credit card machine number is the same for every receipt ("78"). Because there will be a different AR customer on each receipt, you want the deposit description to show the customer name. The following reference and description accomplish this:
- Deposit Reference: 78 - <Receipt Reference>
- Deposit Description: <Customer Name>
-
In the Receipt Types field, select the receipt types allowed by the deposit type. If you enter multiple receipt types, separate them with commas. A receipt is only included in a deposit if the deposit type allows its receipt type.
Note
The Ctrl and Shift selection features are available in the Find dialog box so you can select multiple receipt types. If you use this method to enter receipt types, ActivityHD automatically separates your selections by commas.
-
If you want deposits of this type to only contain one receipt per deposit, mark the One Receipt per Deposit checkbox.
Example
Suppose you are creating a deposit type for a credit card machine. Each "batch out" of a credit card machine generates a single deposit at the bank. Mark the One Receipt per Deposit checkbox so that you can create a separate receipt for each "batch out". This allows you to record the batch number in the receipt reference. This means you can have multiple "batch outs" from the same credit card machine on the same day. Creating a separate deposit for each receipt facilitates bank reconciliation.
- Save the new deposit type.
Create deposits for assignment to receipts later
The Create Deposits wizard allows you to create deposits that can subsequently be assigned to receipts as the receipts are entered. This process generates a series of deposits for a range of dates you specify, one deposit per selected type per day.
- In the Navigation pane, highlight the Accounts Receivable > Setup > Deposit Types folder.
- Start the Create Deposits wizard.
- To create deposits for all or a filtered subset of deposit types:
- Right-click the Deposit Types folder and select Select and Create Deposits from the shortcut menu.
- On the Selection tab, define any filters to apply to the data.
- To create deposits for specifically selected deposit types:
- In the HD view, select the deposit types to create deposits for. You can use Ctrl and/or Shift selection to select multiple records.
- Click .
- To create deposits for a particular deposit type from the Deposit Type window:
- In the HD view, locate and double-click the deposit type you want to create deposits for. The Deposit Type window opens with the deposit type record loaded.
- Click .
- To create deposits for all or a filtered subset of deposit types:
- On the Options tab in the date fields, enter the range of dates to create deposits for.
Note
Deposits of a given deposit type are only created for the days in the specified date range that do not already have a deposit of that type created.
- Click Next >>. ActivityHD prompts you to confirm that you want to create the deposits.
- Click Yes. ActivityHD creates the deposits.
- Click Next >>. ActivityHD lists the deposits you created. All deposits created in this process have an initial status of "New".
- Click Finish.
Purpose
The Deposit Types Listing provides a list of the deposit types defined in your system.
Content
For each deposit type included on the report, the listing shows:
- deposit type code
- description
- GL batch
- bank account
- receipt types which can use the deposit type
- whether deposits of the type allow only one receipt.
In addition, you can include one or more of the following:
- deposit references and descriptions
- timestamps
- memos
- custom fields.
The following total appears on the report:
- record count.
Print the report
- In the Navigation pane, highlight the Accounts Receivable > Setup > Deposit Types folder.
- Start the report set-up wizard.
- To report on all or a filtered subset of deposit types:
- Right-click the Deposit Types folder and select Select and Report > Deposit Types Listing from the shortcut menu.
- On the Selection tab, define any filters to apply to the data.
- To report on specifically selected deposit types:
- In the HD view, select the deposit types to include on the report. You can use Ctrl and/or Shift selection to select multiple records.
- Click .
- To report on a particular deposit type from the Deposit Type window:
- In the HD view, locate and double-click the deposit type to report on. The Deposit Type window opens with the deposit type loaded.
- Click .
- To report on all or a filtered subset of deposit types:
- Select the Options tab.
- Mark the checkbox(es) for the additional information to include:
- Deposit References and Deposit Descriptions
- Timestamps
- Memos
- Custom Fields (only visible if custom fields are set up)
- Select the Output tab.
- In the Design field, look up and select the report design to use.
- In the toolbar, click the icon for the type of output you want:
- - Provides access to two preview options.
- Preview - Click the icon or click the drop-down arrow and select Preview from the drop-down menu to view the report in the Crystal Reports viewer.
- Preview to PDF - Click the drop-down arrow next to the icon and select Preview to PDF to view the report in the PDF reader.
- - Opens the Print dialog so that you can select and configure a printer and then print a paper copy of the report.
- - Opens the Report Email dialog so that you can address and compose an email that the report will be attached to. For best results, ensure your email client is running before you attempt to send a report via email.
- - Opens the Export Report dialog so that you can save the report to a file. File types include Crystal Reports (.rpt), PDF (.pdf), Microsoft Excel (.xls), Microsoft Word (.doc), rich text (.rtf), and XML (.xml).
- - Provides access to two preview options.
Data extensions
The following data extension is available for the report:
- Deposit types
Deposit Type Record ID
A unique code for the deposit type.
Examples
Consider the following possible deposit types:
- Cash/Checks
- MC/Visa
- AMEX
- Lock Box
- PayPal
Deposit Type tab
The bank account to post deposit receipts to for this deposit type. All receipts for a given deposit type must post to the same bank account to ensure the appropriate bank reconciliation is generated.
Press F2 to open the Account Expand dialog box where you can look up an account number, find an account number by its alias, build the account number by segment, or view setup and setup sources.
Press F3 to look up the account.
If an account is already selected, you can press F4 to open the record in the Account window.
The literal text and/or keywords to use to generate the deposit reference that appears on deposits of this type. The deposit reference can be up to 20 characters long. The reference is copied to the bank reconciliation transaction's Reference field when the transaction is created during GL merge.
Note
Changes to the deposit type do not affect existing deposits, so you can change how the deposit reference is generated on future deposits without impacting existing deposits.
The literal text and/or keywords to use to generate the deposit description that appears on deposits of this type. The deposit description can be up to 40 characters long. The description is copied to the bank reconciliation transaction's Description field when the transaction is created during GL merge.
The receipt type(s) allowed by the deposit type. If you enter multiple receipt types, separate them with commas. A receipt is only included in a deposit if the deposit type allows its receipt type.
Note
The Ctrl and Shift selection features are available in the Find dialog box so you can select multiple receipt types. If you use this method to enter receipt types, ActivityHD automatically separates your selections by commas.
Press F2 to open a dialog box where you can add and remove selections for this field.
Press F3 to look up the item.
If this checkbox is marked, indicates that deposits of this type only contain one receipt per deposit.
Example
Suppose you are creating a deposit type for a credit card machine. Each "batch out" of a credit card machine generates a single deposit at the bank. Mark the One Receipt per Deposit checkbox so that you can create a separate receipt for each "batch out". This allows you to record the batch number in the receipt reference. This means you can have multiple "batch outs" from the same credit card machine on the same day. Creating a separate deposit for each receipt facilitates bank reconciliation.
Custom tab
This tab is visible if custom fields exist for the entity. At a minimum, if there are custom fields, a Fields subtab will be present. One or more additional categories of subtabs may also be visible.
Fields subtab
This tab prompts for values for any custom fields set up for entity records of this entity type. Respond to the prompts as appropriate.
References subtab
This tab is visible if other records reference the current record.
Example
Suppose a custom field exists on PRCodes that references an ARCode. On the ARCode record, on the Custom > References subtab, you can view all the PRCodes which reference that ARCode.
Exchange Folder subtab
This tab is visible only if you set up a custom field with a data type of "Exchange Folder". The label on this tab is the name assigned to the custom field.
This tab shows the contents of the specified Exchange folder.
File subtab
This tab is visible only if you set up a custom field with a data type of "File". The label on the tab is the name assigned to the custom field.
This tab renders the contents of the specified file according to its file type.
Internet Address subtab
This tab is visible only if you set up a custom field with a data type of "Internet Address". The label on this tab is the name assigned to the custom field.
This tab shows the contents of the specified web page.
Network Folder subtab
This tab is visible only if you set up a custom field with a data type of "Network Folder". The label on this tab is the name assigned to the custom field.
This tab shows the contents of the specified network folder.
Deposits tab
The Deposits pane shows the Deposits HD view filtered to show all deposits of the selected deposit type.
Double-click a row in the pane to drill down to its record in the Deposit window.
Attachments tab
The Attachments tab is visible if any record for a given entity has an attachment. If the Attachments tab is not visible, this implies that no record of the entity type has an attachment on it; however, once an attachment is added to any record of the entity type, the Attachments tab will become available.
Other tab
Deposit types security
Common accesses available on deposit types
Report Email dialog
- Windows user default account. Sends email using the user's Windows default email account. For most users, this is the account configured in Outlook or another email client application.
- Server personal. Sends email using the email configuration for the system or company server and the email address on the current user's authorized user record. The authorized user record must have a confirmed email address.
- Server generic. Sends email using the email configuration and "from" address for the system or company server. This option requires "Send generic" access to the Server Email resource.
AR deposit expression keywords
The lists below shows keywords which can be used in deposit expressions. Deposit expressions can be used to define the deposit reference and deposit description on deposit types.
Deposit information
- <Receipt Count>
- <Deposit Name>
- <Deposit Type>
- <Deposit Date>
- <Deposit Instance>
Example
For a multi-receipt deposit, consider these expressions:
- Reference Expression: <Receipt Count> Receipt(s)
- Description Expression: <Deposit Name>
Receipt and customer information
The following keywords are only valid when you specify "one receipt per deposit". Do not use these keywords on multi-receipt deposit types.
- <Receipt Reference>
- <Receipt Description>
- <Customer Code>
- <Customer Name>
Example
Suppose you have a deposit type set up to handle American Express credit card receipts. Since this type of receipt allows only one receipt per deposit, you can use the receipt and customer information keywords. Let's build a reference which contains the credit card machine's ID number (78) and the "batch out" number. The "batch out" number is stored in the Receipt Reference. Because you are using different AR customers to group these charges, you want to show the customer name in the deposit description. These expressions do the trick:
- Reference Expression: 78 - <Receipt Reference>
- Description Expression: <Customer Name>
5225 S Loop 289, #207 Lubbock, TX 79424 806.687.8500 | 800.354.7152 |
© 2024 AccountingWare, LLC All rights reserved. |